create external table jms_dm.dm_tms_shipment_error_scan_detail_dt(
    shipment_no       string comment '任务单号'
    ,waybill_no       string comment '运单号'
    ,shipno_planned_departure_date string comment '任务单规划发车日期'
    ,scan_site_code   string comment '扫描站点代码'
    ,scan_site_name   string comment '扫描站点名称'
    ,next_site_code   string comment '下一站代码'
    ,next_site_name   string comment '下一站名称'
    ,scan_type        string comment '扫描类型'
    ,scan_user_code   string comment '扫描员工代码'
    ,scan_user_name   string comment '扫描员工名称'
    ,scan_time        timestamp comment '扫描时间'
)
comment '干线装载率-错扫明细'
partitioned by (dt string comment '分区日期(任务单规划发车日期)')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_tms_shipment_error_scan_detail_dt'
;
